Mysqllongtextlengthlimit

ATEXTcolumnwithamaximumlengthof16,777,215(224−1)characters.Theeffectivemaximumlengthislessifthevaluecontainsmultibytecharacters.Each ...,LONGTEXTcanstorethemaximumcharactersamongallfour,upto4,294,967,295charactersi,e4,294,967,295bytesor4GB.Thisismorethanenoughstoragefor ...,ATEXTcolumnwithamaximumlengthof4,294,967,295or4GB(232-1)characters.Theeffectivemaximumlengthislessifthevaluecontainsmulti...

參考資訊如下
13.3.1 String Data Type Syntax

A TEXT column with a maximum length of 16,777,215 (224 − 1) characters. The effective maximum length is less if the value contains multibyte characters. Each ...

A Guide to Data Types in MySQL for Data Science Beginners

LONGTEXT can store the maximum characters among all four, up to 4,294,967,295 characters i,e 4,294,967,295 bytes or 4GB. This is more than enough storage for ...

LONGTEXT

A TEXT column with a maximum length of 4,294,967,295 or 4GB ( 232 - 1 ) characters. The effective maximum length is less if the value contains multi-byte ...

Maximum length for MySQL type text

2011年7月20日 — LONGTEXT is a string data type with a maximum length of 4,294,967,295 characters. Use LONGTEXT if you need to store large text, such as a ...

mysql

2012年12月18日 — From the documentation: A TEXT column with a maximum length of 255 (28 – 1) characters. The effective maximum length is less if the value ...

MySQL 8.0 Reference Manual :

LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row size, including BLOB and TEXT columns, must be less than 4GB. If a row is less than half ...

MySQL TEXT Types: Size Guide & Usage

MySQL TEXT 格式的長度限制

2009年10月20日 — MySQL TEXT 格式長度列表 · TINYTEXT: 256 bytes · TEXT: 65,535 bytes => ~64kb · MEDIUMTEXT: 16,777,215 bytes => ~16MB · LONGTEXT: 4,294,967,295 bytes ...

VARCHAR vs. TEXT for MySQL Databases

2021年10月7日 — LONGTEXT has a maximum length of about 4 gigabytes. In many respects, TEXT is similar to VARCHAR: it stores variable-length strings up to 65,535 ...

What is the maximum length for a MySQL text field?

2015年6月28日 — LONGTEXT: The maximum length is 4,294,967,295 bytes. MSSQL (Microsoft SQL Server): VARCHAR(MAX): Limited to 2^31-1 bytes (2,147,483,647 bytes).